Plane Profiling Report

Dataset statistics

Number of variables	34
Number of observations	133186
Missing cells	2227561
Missing cells (%)	49.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	124.6 MiB
Average record size in memory	980.6 B

Variable types

CAT	14
NUM	12
UNSUPPORTED	8

Warnings

`Serial Number` has a high cardinality: 73304 distinct values	High cardinality
`MFR MDL Code` has a high cardinality: 16468 distinct values	High cardinality
`Name` has a high cardinality: 76125 distinct values	High cardinality
`Street 1` has a high cardinality: 69976 distinct values	High cardinality
`Street2` has a high cardinality: 1617 distinct values	High cardinality
`City` has a high cardinality: 10931 distinct values	High cardinality
`State` has a high cardinality: 58 distinct values	High cardinality
`ZIP` has a high cardinality: 65555 distinct values	High cardinality
`Country` has a high cardinality: 62 distinct values	High cardinality
`Certification Requested` has a high cardinality: 181 distinct values	High cardinality
`Expiration Date` is highly correlated with `Last Activity Date`	High correlation
`Last Activity Date` is highly correlated with `Expiration Date`	High correlation
`Region` is highly correlated with `State`	High correlation
`State` is highly correlated with `Region` and 1 other fields	High correlation
`Country` is highly correlated with `State`	High correlation
`Serial Number` has 43927 (33.0%) missing values	Missing
`MFR MDL Code` has 43927 (33.0%) missing values	Missing
`Eng MFR Code` has 54315 (40.8%) missing values	Missing
`Year MFR` has 57914 (43.5%) missing values	Missing
`Type Registrant` has 133186 (100.0%) missing values	Missing
`Street 1` has 27261 (20.5%) missing values	Missing
`Street2` has 126188 (94.7%) missing values	Missing
`City` has 26966 (20.2%) missing values	Missing
`State` has 27500 (20.6%) missing values	Missing
`ZIP` has 27075 (20.3%) missing values	Missing
`Region` has 26954 (20.2%) missing values	Missing
`County` has 27669 (20.8%) missing values	Missing
`Country` has 26967 (20.2%) missing values	Missing
`Last Activity Date` has 43927 (33.0%) missing values	Missing
`Cert Issue Date` has 51433 (38.6%) missing values	Missing
`Certification Requested` has 55743 (41.9%) missing values	Missing
`Type Aircraft` has 43927 (33.0%) missing values	Missing
`Type Engine` has 43927 (33.0%) missing values	Missing
`Fractional Ownership` has 133165 (> 99.9%) missing values	Missing
`Airworthiness Date` has 62700 (47.1%) missing values	Missing
`Other Name 1` has 133186 (100.0%) missing values	Missing
`Other Name 2` has 133186 (100.0%) missing values	Missing
`Other Name 3` has 133186 (100.0%) missing values	Missing
`Other Name 4` has 133186 (100.0%) missing values	Missing
`Other Name 5` has 133186 (100.0%) missing values	Missing
`Expiration Date` has 36507 (27.4%) missing values	Missing
`Unique ID` has 43927 (33.0%) missing values	Missing
`Kit MFR Code` has 129937 (97.6%) missing values	Missing
`Kit Model` has 133186 (100.0%) missing values	Missing
`Mose S Code Hex` has 133186 (100.0%) missing values	Missing
`Year MFR` is highly skewed (γ1 = -30.04201046)	Skewed
`N-Number` has unique values	Unique
`Type Registrant` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Other Name 1` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Other Name 2` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Other Name 3` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Other Name 4` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Other Name 5` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Kit Model` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Mose S Code Hex` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Eng MFR Code` has 2725 (2.0%) zeros	Zeros
`Type Engine` has 3100 (2.3%) zeros	Zeros

Reproduction

Analysis started	2022-01-09 07:19:48.314420
Analysis finished	2022-01-09 07:20:12.236386
Duration	23.92 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

N-Number
Categorical

UNIQUE

Distinct	133186
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	1.0 MiB

1AJ	1
787WA	1
591HW	1
930MV	1
930BZ	1
Other values (133181)	133181

Common Values
Overview

Value	Count	Frequency (%)
1AJ	1	< 0.1%
787WA	1	< 0.1%
591HW	1	< 0.1%
930MV	1	< 0.1%
930BZ	1	< 0.1%
930RS	1	< 0.1%
930XS	1	< 0.1%
930DX	1	< 0.1%
2841P	1	< 0.1%
2825	1	< 0.1%
2833	1	< 0.1%
2823P	1	< 0.1%
2749C	1	< 0.1%
1701B	1	< 0.1%
5652L	1	< 0.1%
824B	1	< 0.1%
90604	1	< 0.1%
154AN	1	< 0.1%
79PG	1	< 0.1%
390RA	1	< 0.1%
622QP	1	< 0.1%
2834M	1	< 0.1%
509PT	1	< 0.1%
330AA	1	< 0.1%
82398	1	< 0.1%
Other values (133161)	133161	> 99.9%

Frequencies of value counts

Unique

Unique	133186 ?
Unique (%)	100.0%

Histogram of lengths of the category

Length

Max length	5
Median length	5
Mean length	4.978413647
Min length	1

Overview of Unicode Properties

Unique unicode characters	35
Unique unicode categories	3 ?
Unique unicode scripts	2 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
1	55367	8.4%
2	53652	8.1%
3	49683	7.5%
5	49051	7.4%
4	48209	7.3%
7	47760	7.2%
6	46652	7.0%
8	46345	7.0%
9	45204	6.8%
0	40415	6.1%
	18826	2.8%
A	11238	1.7%
C	9612	1.4%
S	9275	1.4%
B	8849	1.3%
M	8530	1.3%
D	8154	1.2%
T	7783	1.2%
P	7721	1.2%
R	7588	1.1%
H	7022	1.1%
J	6931	1.0%
W	6841	1.0%
E	6632	1.0%
G	6521	1.0%
Other values (10)	49194	7.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	482338	72.7%
Uppercase Letter	161891	24.4%
Space Separator	18826	2.8%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
1	55367	11.5%
2	53652	11.1%
3	49683	10.3%
5	49051	10.2%
4	48209	10.0%
7	47760	9.9%
6	46652	9.7%
8	46345	9.6%
9	45204	9.4%
0	40415	8.4%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
A	11238	6.9%
C	9612	5.9%
S	9275	5.7%
B	8849	5.5%
M	8530	5.3%
D	8154	5.0%
T	7783	4.8%
P	7721	4.8%
R	7588	4.7%
H	7022	4.3%
J	6931	4.3%
W	6841	4.2%
E	6632	4.1%
G	6521	4.0%
F	6252	3.9%
K	6201	3.8%
L	6193	3.8%
V	5307	3.3%
N	5159	3.2%
X	4821	3.0%
U	4308	2.7%
Z	3958	2.4%
Y	3533	2.2%
Q	3462	2.1%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	18826	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	501164	75.6%
Latin	161891	24.4%

Most frequent Common characters

Value	Count	Frequency (%)
1	55367	11.0%
2	53652	10.7%
3	49683	9.9%
5	49051	9.8%
4	48209	9.6%
7	47760	9.5%
6	46652	9.3%
8	46345	9.2%
9	45204	9.0%
0	40415	8.1%
	18826	3.8%

Most frequent Latin characters

Value	Count	Frequency (%)
A	11238	6.9%
C	9612	5.9%
S	9275	5.7%
B	8849	5.5%
M	8530	5.3%
D	8154	5.0%
T	7783	4.8%
P	7721	4.8%
R	7588	4.7%
H	7022	4.3%
J	6931	4.3%
W	6841	4.2%
E	6632	4.1%
G	6521	4.0%
F	6252	3.9%
K	6201	3.8%
L	6193	3.8%
V	5307	3.3%
N	5159	3.2%
X	4821	3.0%
U	4308	2.7%
Z	3958	2.4%
Y	3533	2.2%
Q	3462	2.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	663055	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
1	55367	8.4%
2	53652	8.1%
3	49683	7.5%
5	49051	7.4%
4	48209	7.3%
7	47760	7.2%
6	46652	7.0%
8	46345	7.0%
9	45204	6.8%
0	40415	6.1%
	18826	2.8%
A	11238	1.7%
C	9612	1.4%
S	9275	1.4%
B	8849	1.3%
M	8530	1.3%
D	8154	1.2%
T	7783	1.2%
P	7721	1.2%
R	7588	1.1%
H	7022	1.1%
J	6931	1.0%
W	6841	1.0%
E	6632	1.0%
G	6521	1.0%
Other values (10)	49194	7.4%

Serial Number
Categorical

HIGH CARDINALITY
MISSING

Distinct	73304
Distinct (%)	82.1%
Missing	43927
Missing (%)	33.0%
Memory size	1.0 MiB

1	1173
2	162
3	112
4	67
5	66
Other values (73299)	87679

Common Values
Overview

Value	Count	Frequency (%)
1	1173	0.9%
2	162	0.1%
3	112	0.1%
4	67	0.1%
5	66	< 0.1%
7	62	< 0.1%
101	61	< 0.1%
1001	52	< 0.1%
6	50	< 0.1%
10	39	< 0.1%
100	38	< 0.1%
8	36	< 0.1%
11	32	< 0.1%
12	32	< 0.1%
38	31	< 0.1%
18	29	< 0.1%
16	28	< 0.1%
9	28	< 0.1%
103	28	< 0.1%
14	27	< 0.1%
19	27	< 0.1%
107	26	< 0.1%
102	26	< 0.1%
42	26	< 0.1%
13	25	< 0.1%
Other values (73279)	86976	65.3%
(Missing)	43927	33.0%

Frequencies of value counts

Unique

Unique	68111 ?
Unique (%)	76.3%

Histogram of lengths of the category

Length

Max length	30
Median length	5
Mean length	12.01735918
Min length	1

Overview of Unicode Properties

Unique unicode characters	62
Unique unicode categories	10 ?
Unique unicode scripts	2 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
	900602	56.3%
n	87944	5.5%
1	75786	4.7%
2	67470	4.2%
0	64318	4.0%
7	45607	2.8%
5	45426	2.8%
a	43962	2.7%
8	42014	2.6%
3	41732	2.6%
4	38664	2.4%
6	38281	2.4%
-	31635	2.0%
9	28599	1.8%
A	6911	0.4%
C	6563	0.4%
D	4159	0.3%
R	3261	0.2%
B	2948	0.2%
S	2459	0.2%
T	2444	0.2%
E	2332	0.1%
P	2128	0.1%
H	1729	0.1%
F	1434	0.1%
Other values (37)	12136	0.8%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	900602	56.3%
Decimal Number	487897	30.5%
Lowercase Letter	132741	8.3%
Uppercase Letter	46891	2.9%
Dash Punctuation	31635	2.0%
Other Punctuation	717	< 0.1%
Math Symbol	31	< 0.1%
Open Punctuation	10	< 0.1%
Close Punctuation	10	< 0.1%
Connector Punctuation	10	< 0.1%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
1	75786	15.5%
2	67470	13.8%
0	64318	13.2%
7	45607	9.3%
5	45426	9.3%
8	42014	8.6%
3	41732	8.6%
4	38664	7.9%
6	38281	7.8%
9	28599	5.9%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
A	6911	14.7%
C	6563	14.0%
D	4159	8.9%
R	3261	7.0%
B	2948	6.3%
S	2459	5.2%
T	2444	5.2%
E	2332	5.0%
P	2128	4.5%
H	1729	3.7%
F	1434	3.1%
M	1392	3.0%
L	1334	2.8%
G	1086	2.3%
W	1063	2.3%
J	871	1.9%
V	782	1.7%
U	768	1.6%
N	687	1.5%
K	669	1.4%
X	598	1.3%
I	567	1.2%
O	307	0.7%
Y	176	0.4%
Q	125	0.3%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	900602	100.0%

Most frequent Dash Punctuation characters

Value	Count	Frequency (%)
-	31635	100.0%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
n	87944	66.3%
a	43962	33.1%
e	277	0.2%
c	272	0.2%
u	142	0.1%
l	55	< 0.1%
y	17	< 0.1%
o	16	< 0.1%
v	16	< 0.1%
r	11	< 0.1%
p	9	< 0.1%
g	9	< 0.1%
b	6	< 0.1%
t	5	< 0.1%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
.	448	62.5%
/	253	35.3%
:	8	1.1%
#	7	1.0%
&	1	0.1%

Most frequent Open Punctuation characters

Value	Count	Frequency (%)
(	10	100.0%

Most frequent Close Punctuation characters

Value	Count	Frequency (%)
)	10	100.0%

Most frequent Math Symbol characters

Value	Count	Frequency (%)
+	28	90.3%
=	3	9.7%

Most frequent Connector Punctuation characters

Value	Count	Frequency (%)
_	10	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1420912	88.8%
Latin	179632	11.2%

Most frequent Common characters

Value	Count	Frequency (%)
	900602	63.4%
1	75786	5.3%
2	67470	4.7%
0	64318	4.5%
7	45607	3.2%
5	45426	3.2%
8	42014	3.0%
3	41732	2.9%
4	38664	2.7%
6	38281	2.7%
-	31635	2.2%
9	28599	2.0%
.	448	< 0.1%
/	253	< 0.1%
+	28	< 0.1%
(	10	< 0.1%
)	10	< 0.1%
_	10	< 0.1%
:	8	< 0.1%
#	7	< 0.1%
=	3	< 0.1%
&	1	< 0.1%

Most frequent Latin characters

Value	Count	Frequency (%)
n	87944	49.0%
a	43962	24.5%
A	6911	3.8%
C	6563	3.7%
D	4159	2.3%
R	3261	1.8%
B	2948	1.6%
S	2459	1.4%
T	2444	1.4%
E	2332	1.3%
P	2128	1.2%
H	1729	1.0%
F	1434	0.8%
M	1392	0.8%
L	1334	0.7%
G	1086	0.6%
W	1063	0.6%
J	871	0.5%
V	782	0.4%
U	768	0.4%
N	687	0.4%
K	669	0.4%
X	598	0.3%
I	567	0.3%
O	307	0.2%
Other values (15)	1234	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1600544	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
	900602	56.3%
n	87944	5.5%
1	75786	4.7%
2	67470	4.2%
0	64318	4.0%
7	45607	2.8%
5	45426	2.8%
a	43962	2.7%
8	42014	2.6%
3	41732	2.6%
4	38664	2.4%
6	38281	2.4%
-	31635	2.0%
9	28599	1.8%
A	6911	0.4%
C	6563	0.4%
D	4159	0.3%
R	3261	0.2%
B	2948	0.2%
S	2459	0.2%
T	2444	0.2%
E	2332	0.1%
P	2128	0.1%
H	1729	0.1%
F	1434	0.1%
Other values (37)	12136	0.8%

MFR MDL Code
Categorical

HIGH CARDINALITY
MISSING

Distinct	16468
Distinct (%)	18.4%
Missing	43927
Missing (%)	33.0%
Memory size	1.0 MiB

7100510	1504
7102802	1267
2072418	1000
7102808	958
2110102	936
Other values (16463)	83594

Common Values
Overview

Value	Count	Frequency (%)
7100510	1504	1.1%
7102802	1267	1.0%
2072418	1000	0.8%
7102808	958	0.7%
2110102	936	0.7%
2072434	880	0.7%
2130001	784	0.6%
2071602	707	0.5%
2072402	612	0.5%
8190104	583	0.4%
2075816	578	0.4%
7101828	563	0.4%
7102807	557	0.4%
7102210	542	0.4%
2071835	541	0.4%
7101202	524	0.4%
2071826	479	0.4%
061008I	466	0.3%
2072306	462	0.3%
2072439	461	0.3%
8850316	455	0.3%
06101C2	443	0.3%
2071830	438	0.3%
1151604	435	0.3%
7102803	430	0.3%
Other values (16443)	72654	54.6%
(Missing)	43927	33.0%

Frequencies of value counts

Unique

Unique	13255 ?
Unique (%)	14.9%

Histogram of lengths of the category

Length

Max length	8
Median length	7
Mean length	5.645758563
Min length	3

Overview of Unicode Properties

Unique unicode characters	40
Unique unicode categories	5 ?
Unique unicode scripts	2 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
0	147355	19.6%
1	96248	12.8%
2	93696	12.5%
n	87854	11.7%
7	53340	7.1%
a	43927	5.8%
5	39165	5.2%
6	38200	5.1%
3	38103	5.1%
8	37464	5.0%
4	36393	4.8%
9	15891	2.1%
C	1848	0.2%
N	1374	0.2%
I	1346	0.2%
A	1320	0.2%
B	1187	0.2%
Y	938	0.1%
K	916	0.1%
P	908	0.1%
G	897	0.1%
M	888	0.1%
D	878	0.1%
J	872	0.1%
L	854	0.1%
Other values (15)	10074	1.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	595855	79.2%
Lowercase Letter	131781	17.5%
Uppercase Letter	24114	3.2%
Other Punctuation	93	< 0.1%
Math Symbol	93	< 0.1%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
0	147355	24.7%
1	96248	16.2%
2	93696	15.7%
7	53340	9.0%
5	39165	6.6%
6	38200	6.4%
3	38103	6.4%
8	37464	6.3%
4	36393	6.1%
9	15891	2.7%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
C	1848	7.7%
N	1374	5.7%
I	1346	5.6%
A	1320	5.5%
B	1187	4.9%
Y	938	3.9%
K	916	3.8%
P	908	3.8%
G	897	3.7%
M	888	3.7%
D	878	3.6%
J	872	3.6%
L	854	3.5%
E	849	3.5%
R	838	3.5%
F	832	3.5%
X	804	3.3%
H	797	3.3%
U	771	3.2%
V	764	3.2%
Z	750	3.1%
S	729	3.0%
Q	715	3.0%
T	695	2.9%
O	695	2.9%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
n	87854	66.7%
a	43927	33.3%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
.	93	100.0%

Most frequent Math Symbol characters

Value	Count	Frequency (%)
+	93	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	596041	79.3%
Latin	155895	20.7%

Most frequent Common characters

Value	Count	Frequency (%)
0	147355	24.7%
1	96248	16.1%
2	93696	15.7%
7	53340	8.9%
5	39165	6.6%
6	38200	6.4%
3	38103	6.4%
8	37464	6.3%
4	36393	6.1%
9	15891	2.7%
.	93	< 0.1%
+	93	< 0.1%

Most frequent Latin characters

Value	Count	Frequency (%)
n	87854	56.4%
a	43927	28.2%
C	1848	1.2%
N	1374	0.9%
I	1346	0.9%
A	1320	0.8%
B	1187	0.8%
Y	938	0.6%
K	916	0.6%
P	908	0.6%
G	897	0.6%
M	888	0.6%
D	878	0.6%
J	872	0.6%
L	854	0.5%
E	849	0.5%
R	838	0.5%
F	832	0.5%
X	804	0.5%
H	797	0.5%
U	771	0.5%
V	764	0.5%
Z	750	0.5%
S	729	0.5%
Q	715	0.5%
Other values (3)	2039	1.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	751936	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
0	147355	19.6%
1	96248	12.8%
2	93696	12.5%
n	87854	11.7%
7	53340	7.1%
a	43927	5.8%
5	39165	5.2%
6	38200	5.1%
3	38103	5.1%
8	37464	5.0%
4	36393	4.8%
9	15891	2.1%
C	1848	0.2%
N	1374	0.2%
I	1346	0.2%
A	1320	0.2%
B	1187	0.2%
Y	938	0.1%
K	916	0.1%
P	908	0.1%
G	897	0.1%
M	888	0.1%
D	878	0.1%
J	872	0.1%
L	854	0.1%
Other values (15)	10074	1.3%

Eng MFR Code
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	1481
Distinct (%)	1.9%
Missing	54315
Missing (%)	40.8%
Infinite	0
Infinite (%)	0.0%

Mean	32923.49603
Minimum	0
Maximum	99999
Zeros	2725
Zeros (%)	2.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	0
5-th percentile	9050
Q1	17022
median	41505
Q3	41532
95-th percentile	59050
Maximum	99999
Range	99999
Interquartile range (IQR)	24510

Descriptive statistics

Standard deviation	18955.48391
Coefficient of variation (CV)	0.5757433506
Kurtosis	1.812383558
Mean	32923.49603
Median Absolute Deviation (MAD)	14472
Skewness	0.9024366545
Sum	2596709055
Variance	359310370.4
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41508	8459	6.4%
17003	4372	3.3%
17026	3677	2.8%
41514	3540	2.7%
17020	3017	2.3%
0	2725	2.0%
17032	2557	1.9%
41505	2409	1.8%
17008	2285	1.7%
17022	2071	1.6%
99999	1929	1.4%
41515	1708	1.3%
41532	1588	1.2%
41533	1323	1.0%
17027	1246	0.9%
41506	1029	0.8%
17040	1002	0.8%
41530	964	0.7%
52008	933	0.7%
17009	897	0.7%
17005	886	0.7%
9050	796	0.6%
17012	677	0.5%
17042	670	0.5%
55572	631	0.5%
Other values (1456)	27480	20.6%
(Missing)	54315	40.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2725	2.0%
401	5	< 0.1%
402	3	< 0.1%
500	2	< 0.1%
501	1	< 0.1%
511	2	< 0.1%
1001	2	< 0.1%
1002	26	< 0.1%
1007	1	< 0.1%
1300	9	< 0.1%

Value	Count	Frequency (%)
99999	1929	1.4%
83359	1	< 0.1%
80000	5	< 0.1%
75001	2	< 0.1%
72000	8	< 0.1%
70004	2	< 0.1%
67270	1	< 0.1%
67209	1	< 0.1%
67205	2	< 0.1%
67204	1	< 0.1%

Year MFR
Real number (ℝ_≥0)

MISSING
SKEWED

Distinct	104
Distinct (%)	0.1%
Missing	57914
Missing (%)	43.5%
Infinite	0
Infinite (%)	0.0%

Mean	1973.325513
Minimum	0
Maximum	2016
Zeros	47
Zeros (%)	< 0.1%
Memory size	1.0 MiB

Quantile statistics

Minimum	0
5-th percentile	1943
Q1	1958
median	1973
Q3	1993
95-th percentile	2013
Maximum	2016
Range	2016
Interquartile range (IQR)	35

Descriptive statistics

Standard deviation	54.79692543
Coefficient of variation (CV)	0.02776882226
Kurtosis	1076.704885
Mean	1973.325513
Median Absolute Deviation (MAD)	17
Skewness	-30.04201046
Sum	148536158
Variance	3002.703037
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1946	5148	3.9%
2015	2111	1.6%
1978	2021	1.5%
1966	2014	1.5%
1976	1944	1.5%
1977	1920	1.4%
1947	1895	1.4%
1979	1791	1.3%
1968	1759	1.3%
1967	1718	1.3%
1975	1680	1.3%
1965	1569	1.2%
1974	1547	1.2%
1973	1536	1.2%
1969	1476	1.1%
2007	1303	1.0%
1972	1261	0.9%
1964	1247	0.9%
2006	1150	0.9%
1959	1143	0.9%
2005	1133	0.9%
2008	1085	0.8%
1981	1078	0.8%
1980	1074	0.8%
1941	1004	0.8%
Other values (79)	33665	25.3%
(Missing)	57914	43.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	47	< 0.1%
195	1	< 0.1%
196	1	< 0.1%
1910	1	< 0.1%
1911	1	< 0.1%
1916	1	< 0.1%
1917	2	< 0.1%
1918	2	< 0.1%
1920	1	< 0.1%
1922	1	< 0.1%

Value	Count	Frequency (%)
2016	970	0.7%
2015	2111	1.6%
2014	573	0.4%
2013	360	0.3%
2012	689	0.5%
2011	268	0.2%
2010	406	0.3%
2009	778	0.6%
2008	1085	0.8%
2007	1303	1.0%

Type Registrant
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	133186
Missing (%)	100.0%
Memory size	1.0 MiB

Name
Categorical

HIGH CARDINALITY

Distinct	76125
Distinct (%)	57.2%
Missing	215
Missing (%)	0.2%
Memory size	1.0 MiB

CANCELLED/NOT ASSIGNED	26749
SALE REPORTED	884
REGISTRATION PENDING	780
WELLS FARGO BANK NORTHWEST NA TRUSTEE	765
SOUTHWEST AIRLINES CO	533
Other values (76120)	103260

Common Values
Overview

Value	Count	Frequency (%)
CANCELLED/NOT ASSIGNED	26749	20.1%
SALE REPORTED	884	0.7%
REGISTRATION PENDING	780	0.6%
WELLS FARGO BANK NORTHWEST NA TRUSTEE	765	0.6%
SOUTHWEST AIRLINES CO	533	0.4%
TEXTRON AVIATION INC	449	0.3%
AMERICAN AIRLINES INC	405	0.3%
GULFSTREAM AEROSPACE CORP	377	0.3%
SHORT-N-NUMBERS	309	0.2%
BANK OF UTAH TRUSTEE	301	0.2%
DELTA AIR LINES INC	279	0.2%
FEDERAL EXPRESS CORP	270	0.2%
CESSNA AIRCRAFT COMPANY	240	0.2%
UNITED AIRLINES INC	235	0.2%
AIRCRAFT GUARANTY CORP TRUSTEE	226	0.2%
CIRRUS DESIGN CORP	195	0.1%
BOEING CO	176	0.1%
NETJETS SALES INC	173	0.1%
SOUTHERN AIRCRAFT CONSULTANCY INC TRUSTEE	152	0.1%
PIPER AIRCRAFT INC	144	0.1%
AIR TRACTOR INC	138	0.1%
WILMINGTON TRUST CO TRUSTEE	126	0.1%
CESSNA AIRCRAFT CO	123	0.1%
CIVIL AIR PATROL	119	0.1%
US DOI OFFICE OF AVIATION SERVICES	107	0.1%
Other values (76100)	98716	74.1%
(Missing)	215	0.2%

Frequencies of value counts

Unique

Unique	66732 ?
Unique (%)	50.2%

Histogram of lengths of the category

Length

Max length	50
Median length	50
Mean length	49.92412866
Min length	3

Overview of Unicode Properties

Unique unicode characters	52
Unique unicode categories	9 ?
Unique unicode scripts	2 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
	4422797	66.5%
E	243487	3.7%
N	209287	3.1%
A	208189	3.1%
L	173146	2.6%
I	159768	2.4%
S	149737	2.3%
C	146445	2.2%
R	145123	2.2%
O	128590	1.9%
T	124137	1.9%
D	103696	1.6%
G	61954	0.9%
H	48365	0.7%
M	45030	0.7%
U	34196	0.5%
P	33037	0.5%
B	27722	0.4%
/	27028	0.4%
Y	26409	0.4%
F	24619	0.4%
W	23872	0.4%
V	23552	0.4%
K	21862	0.3%
J	19991	0.3%
Other values (27)	17156	0.3%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	4422797	66.5%
Uppercase Letter	2189918	32.9%
Other Punctuation	28834	0.4%
Decimal Number	5415	0.1%
Dash Punctuation	1476	< 0.1%
Lowercase Letter	645	< 0.1%
Open Punctuation	52	< 0.1%
Close Punctuation	52	< 0.1%
Math Symbol	6	< 0.1%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
E	243487	11.1%
N	209287	9.6%
A	208189	9.5%
L	173146	7.9%
I	159768	7.3%
S	149737	6.8%
C	146445	6.7%
R	145123	6.6%
O	128590	5.9%
T	124137	5.7%
D	103696	4.7%
G	61954	2.8%
H	48365	2.2%
M	45030	2.1%
U	34196	1.6%
P	33037	1.5%
B	27722	1.3%
Y	26409	1.2%
F	24619	1.1%
W	23872	1.1%
V	23552	1.1%
K	21862	1.0%
J	19991	0.9%
Z	3334	0.2%
X	3333	0.2%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	4422797	100.0%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
/	27028	93.7%
&	1490	5.2%
'	171	0.6%
.	129	0.4%
#	11	< 0.1%
"	2	< 0.1%
?	1	< 0.1%
@	1	< 0.1%
!	1	< 0.1%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
1	811	15.0%
2	802	14.8%
0	622	11.5%
3	562	10.4%
5	527	9.7%
4	493	9.1%
7	443	8.2%
8	406	7.5%
6	383	7.1%
9	366	6.8%

Most frequent Dash Punctuation characters

Value	Count	Frequency (%)
-	1476	100.0%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
n	430	66.7%
a	215	33.3%

Most frequent Open Punctuation characters

Value	Count	Frequency (%)
(	52	100.0%

Most frequent Close Punctuation characters

Value	Count	Frequency (%)
)	52	100.0%

Most frequent Math Symbol characters

Value	Count	Frequency (%)
+	6	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	4458632	67.1%
Latin	2190563	32.9%

Most frequent Latin characters

Value	Count	Frequency (%)
E	243487	11.1%
N	209287	9.6%
A	208189	9.5%
L	173146	7.9%
I	159768	7.3%
S	149737	6.8%
C	146445	6.7%
R	145123	6.6%
O	128590	5.9%
T	124137	5.7%
D	103696	4.7%
G	61954	2.8%
H	48365	2.2%
M	45030	2.1%
U	34196	1.6%
P	33037	1.5%
B	27722	1.3%
Y	26409	1.2%
F	24619	1.1%
W	23872	1.1%
V	23552	1.1%
K	21862	1.0%
J	19991	0.9%
Z	3334	0.2%
X	3333	0.2%
Other values (3)	1682	0.1%

Most frequent Common characters

Value	Count	Frequency (%)
	4422797	99.2%
/	27028	0.6%
&	1490	< 0.1%
-	1476	< 0.1%
1	811	< 0.1%
2	802	< 0.1%
0	622	< 0.1%
3	562	< 0.1%
5	527	< 0.1%
4	493	< 0.1%
7	443	< 0.1%
8	406	< 0.1%
6	383	< 0.1%
9	366	< 0.1%
'	171	< 0.1%
.	129	< 0.1%
(	52	< 0.1%
)	52	< 0.1%
#	11	< 0.1%
+	6	< 0.1%
"	2	< 0.1%
?	1	< 0.1%
@	1	< 0.1%
!	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6649195	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
	4422797	66.5%
E	243487	3.7%
N	209287	3.1%
A	208189	3.1%
L	173146	2.6%
I	159768	2.4%
S	149737	2.3%
C	146445	2.2%
R	145123	2.2%
O	128590	1.9%
T	124137	1.9%
D	103696	1.6%
G	61954	0.9%
H	48365	0.7%
M	45030	0.7%
U	34196	0.5%
P	33037	0.5%
B	27722	0.4%
/	27028	0.4%
Y	26409	0.4%
F	24619	0.4%
W	23872	0.4%
V	23552	0.4%
K	21862	0.3%
J	19991	0.3%
Other values (27)	17156	0.3%

Street 1
Categorical

HIGH CARDINALITY
MISSING

Distinct	69976
Distinct (%)	66.1%
Missing	27261
Missing (%)	20.5%
Memory size	1.0 MiB

3511 SILVERSIDE RD STE 105	965
1 CESSNA BLVD	483
PO BOX 368	323
DAL2MX CERTIFICATE COMPLIANCE	308
2711 CENTERVILLE RD STE 400	296
Other values (69971)	103550

Common Values
Overview

Value	Count	Frequency (%)
3511 SILVERSIDE RD STE 105	965	0.7%
1 CESSNA BLVD	483	0.4%
PO BOX 368	323	0.2%
DAL2MX CERTIFICATE COMPLIANCE	308	0.2%
2711 CENTERVILLE RD STE 400	296	0.2%
200 E SOUTH TEMPLE STE 210	280	0.2%
C/O DEBEE GILCHRIST PC	260	0.2%
MAC U1228-51	244	0.2%
PO BOX 7704	218	0.2%
PO BOX 2549	198	0.1%
1775 M H JACKSON SERVICE RD	185	0.1%
VP SUPPLEMENTAL AIR OPERATIONS	182	0.1%
4515 TAYLOR CIR	176	0.1%
1901 OAKESDALE AVE SW	175	0.1%
16192 COASTAL HWY	159	0.1%
C/O BUSINESS AIRCRAFT TITLE INTL	155	0.1%
PO BOX 485	145	0.1%
2702 LOVE FIELD DR # HDQ-4GC	143	0.1%
MAC U1228-051	135	0.1%
2926 PIPER DR	134	0.1%
C/O IATS	130	0.1%
444 S RIVER RD	109	0.1%
C/O DFPH&J	109	0.1%
3255 BELL HELICOPTER BLVD	100	0.1%
105 S HANSELL ST	98	0.1%
Other values (69951)	100215	75.2%
(Missing)	27261	20.5%

Frequencies of value counts

Unique

Unique	59520 ?
Unique (%)	56.2%

Histogram of lengths of the category

Length

Max length	33
Median length	33
Mean length	26.85860376
Min length	2

Overview of Unicode Properties

Unique unicode characters	53
Unique unicode categories	9 ?
Unique unicode scripts	2 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
	1999896	55.9%
E	104085	2.9%
R	103472	2.9%
A	84674	2.4%
O	81888	2.3%
1	80739	2.3%
T	76908	2.1%
S	67852	1.9%
D	66799	1.9%
N	65704	1.8%
0	63005	1.8%
L	58716	1.6%
n	54522	1.5%
2	53706	1.5%
I	52135	1.5%
5	42688	1.2%
3	41690	1.2%
C	36913	1.0%
4	36380	1.0%
P	32661	0.9%
B	30654	0.9%
H	30274	0.8%
6	29538	0.8%
7	28348	0.8%
a	27261	0.8%
Other values (28)	226682	6.3%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	1999896	55.9%
Uppercase Letter	1061085	29.7%
Decimal Number	426852	11.9%
Lowercase Letter	81783	2.3%
Other Punctuation	5780	0.2%
Dash Punctuation	1779	< 0.1%
Open Punctuation	7	< 0.1%
Close Punctuation	7	< 0.1%
Math Symbol	1	< 0.1%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
E	104085	9.8%
R	103472	9.8%
A	84674	8.0%
O	81888	7.7%
T	76908	7.2%
S	67852	6.4%
D	66799	6.3%
N	65704	6.2%
L	58716	5.5%
I	52135	4.9%
C	36913	3.5%
P	32661	3.1%
B	30654	2.9%
H	30274	2.9%
W	26783	2.5%
V	23829	2.2%
M	20503	1.9%
U	18899	1.8%
Y	18129	1.7%
G	17022	1.6%
X	15090	1.4%
K	13491	1.3%
F	10099	1.0%
J	2405	0.2%
Q	1061	0.1%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	1999896	100.0%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
1	80739	18.9%
0	63005	14.8%
2	53706	12.6%
5	42688	10.0%
3	41690	9.8%
4	36380	8.5%
6	29538	6.9%
7	28348	6.6%
8	25837	6.1%
9	24921	5.8%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
n	54522	66.7%
a	27261	33.3%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
/	2314	40.0%
#	1643	28.4%
:	1048	18.1%
&	523	9.0%
.	228	3.9%
%	13	0.2%
'	7	0.1%
"	2	< 0.1%
@	1	< 0.1%
\	1	< 0.1%

Most frequent Dash Punctuation characters

Value	Count	Frequency (%)
-	1779	100.0%

Most frequent Open Punctuation characters

Value	Count	Frequency (%)
(	7	100.0%

Most frequent Close Punctuation characters

Value	Count	Frequency (%)
)	7	100.0%

Most frequent Math Symbol characters

Value	Count	Frequency (%)
+	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2434322	68.1%
Latin	1142868	31.9%

Most frequent Latin characters

Value	Count	Frequency (%)
E	104085	9.1%
R	103472	9.1%
A	84674	7.4%
O	81888	7.2%
T	76908	6.7%
S	67852	5.9%
D	66799	5.8%
N	65704	5.7%
L	58716	5.1%
n	54522	4.8%
I	52135	4.6%
C	36913	3.2%
P	32661	2.9%
B	30654	2.7%
H	30274	2.6%
a	27261	2.4%
W	26783	2.3%
V	23829	2.1%
M	20503	1.8%
U	18899	1.7%
Y	18129	1.6%
G	17022	1.5%
X	15090	1.3%
K	13491	1.2%
F	10099	0.9%
Other values (3)	4505	0.4%

Most frequent Common characters

Value	Count	Frequency (%)
	1999896	82.2%
1	80739	3.3%
0	63005	2.6%
2	53706	2.2%
5	42688	1.8%
3	41690	1.7%
4	36380	1.5%
6	29538	1.2%
7	28348	1.2%
8	25837	1.1%
9	24921	1.0%
/	2314	0.1%
-	1779	0.1%
#	1643	0.1%
:	1048	< 0.1%
&	523	< 0.1%
.	228	< 0.1%
%	13	< 0.1%
'	7	< 0.1%
(	7	< 0.1%
)	7	< 0.1%
"	2	< 0.1%
@	1	< 0.1%
\	1	< 0.1%
+	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3577190	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
	1999896	55.9%
E	104085	2.9%
R	103472	2.9%
A	84674	2.4%
O	81888	2.3%
1	80739	2.3%
T	76908	2.1%
S	67852	1.9%
D	66799	1.9%
N	65704	1.8%
0	63005	1.8%
L	58716	1.6%
n	54522	1.5%
2	53706	1.5%
I	52135	1.5%
5	42688	1.2%
3	41690	1.2%
C	36913	1.0%
4	36380	1.0%
P	32661	0.9%
B	30654	0.9%
H	30274	0.8%
6	29538	0.8%
7	28348	0.8%
a	27261	0.8%
Other values (28)	226682	6.3%

Street2
Categorical

HIGH CARDINALITY
MISSING

Distinct	1617
Distinct (%)	23.1%
Missing	126188
Missing (%)	94.7%
Memory size	1.0 MiB

1200 NW 63RD ST STE 5000	495
299 S MAIN ST FL 5	466
2832 SHORECREST DR	318
2955 REPUBLICAN DR	182
DEPT 095	166
Other values (1612)	5371

Common Values
Overview

Value	Count	Frequency (%)
1200 NW 63RD ST STE 5000	495	0.4%
299 S MAIN ST FL 5	466	0.3%
2832 SHORECREST DR	318	0.2%
2955 REPUBLICAN DR	182	0.1%
DEPT 095	166	0.1%
324 N ROBINSON AVE STE 100	137	0.1%
100 N BROADWAY STE 2000	132	0.1%
DEPT 595 AIRCRAFT REGISTRATIONS	122	0.1%
3131 DEMOCRAT RD	107	0.1%
PO BOX 19527	92	0.1%
PO BOX 66142	85	0.1%
1400 N HURSTBOURNE PKWY	85	0.1%
1100 N MARKET ST	85	0.1%
MAC U1228-051	82	0.1%
233 S WACKER DR	80	0.1%
100 N BROADWAY AVE STE 2000	80	0.1%
300 E MALLARD DR STE 200	76	0.1%
PO BOX 2216	75	0.1%
5501 JOSH BIRMINGHAM PKWY	75	0.1%
DEPT 595	75	0.1%
PO BOX 10212	75	0.1%
PO BOX 81009	75	0.1%
2207 CONCORD PIKE	70	0.1%
MAC U1228-51	54	< 0.1%
11495 NAVAID RD	54	< 0.1%
Other values (1592)	3655	2.7%
(Missing)	126188	94.7%

Frequencies of value counts

Unique

Unique	1191 ?
Unique (%)	17.0%

Histogram of lengths of the category

Length

Max length	33
Median length	3
Mean length	4.574279579
Min length	2

Overview of Unicode Properties

Unique unicode characters	47
Unique unicode categories	8 ?
Unique unicode scripts	2 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
n	252376	41.4%
a	126188	20.7%
	125370	20.6%
0	8187	1.3%
R	7123	1.2%
E	6996	1.1%
S	6679	1.1%
T	6584	1.1%
A	5616	0.9%
1	5235	0.9%
N	5143	0.8%
O	5043	0.8%
2	4981	0.8%
D	4189	0.7%
I	3663	0.6%
5	3462	0.6%
3	2560	0.4%
L	2545	0.4%
9	2511	0.4%
B	2346	0.4%
C	2342	0.4%
P	2168	0.4%
M	2039	0.3%
W	1626	0.3%
6	1597	0.3%
Other values (22)	12661	2.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	378564	62.1%
Space Separator	125370	20.6%
Uppercase Letter	72869	12.0%
Decimal Number	31928	5.2%
Dash Punctuation	356	0.1%
Other Punctuation	137	< 0.1%
Open Punctuation	3	< 0.1%
Close Punctuation	3	< 0.1%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
n	252376	66.7%
a	126188	33.3%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
0	8187	25.6%
1	5235	16.4%
2	4981	15.6%
5	3462	10.8%
3	2560	8.0%
9	2511	7.9%
6	1597	5.0%
4	1247	3.9%
8	1190	3.7%
7	958	3.0%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	125370	100.0%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
R	7123	9.8%
E	6996	9.6%
S	6679	9.2%
T	6584	9.0%
A	5616	7.7%
N	5143	7.1%
O	5043	6.9%
D	4189	5.7%
I	3663	5.0%
L	2545	3.5%
B	2346	3.2%
C	2342	3.2%
P	2168	3.0%
M	2039	2.8%
W	1626	2.2%
H	1591	2.2%
U	1245	1.7%
V	1232	1.7%
F	1074	1.5%
G	943	1.3%
K	826	1.1%
Y	817	1.1%
X	746	1.0%
J	173	0.2%
Z	74	0.1%

Most frequent Dash Punctuation characters

Value	Count	Frequency (%)
-	356	100.0%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
:	66	48.2%
#	51	37.2%
/	15	10.9%
'	3	2.2%
.	2	1.5%

Most frequent Open Punctuation characters

Value	Count	Frequency (%)
(	3	100.0%

Most frequent Close Punctuation characters

Value	Count	Frequency (%)
)	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	451433	74.1%
Common	157797	25.9%

Most frequent Latin characters

Value	Count	Frequency (%)
n	252376	55.9%
a	126188	28.0%
R	7123	1.6%
E	6996	1.5%
S	6679	1.5%
T	6584	1.5%
A	5616	1.2%
N	5143	1.1%
O	5043	1.1%
D	4189	0.9%
I	3663	0.8%
L	2545	0.6%
B	2346	0.5%
C	2342	0.5%
P	2168	0.5%
M	2039	0.5%
W	1626	0.4%
H	1591	0.4%
U	1245	0.3%
V	1232	0.3%
F	1074	0.2%
G	943	0.2%
K	826	0.2%
Y	817	0.2%
X	746	0.2%
Other values (3)	293	0.1%

Most frequent Common characters

Value	Count	Frequency (%)
	125370	79.5%
0	8187	5.2%
1	5235	3.3%
2	4981	3.2%
5	3462	2.2%
3	2560	1.6%
9	2511	1.6%
6	1597	1.0%
4	1247	0.8%
8	1190	0.8%
7	958	0.6%
-	356	0.2%
:	66	< 0.1%
#	51	< 0.1%
/	15	< 0.1%
(	3	< 0.1%
)	3	< 0.1%
'	3	< 0.1%
.	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	609230	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
n	252376	41.4%
a	126188	20.7%
	125370	20.6%
0	8187	1.3%
R	7123	1.2%
E	6996	1.1%
S	6679	1.1%
T	6584	1.1%
A	5616	0.9%
1	5235	0.9%
N	5143	0.8%
O	5043	0.8%
2	4981	0.8%
D	4189	0.7%
I	3663	0.6%
5	3462	0.6%
3	2560	0.4%
L	2545	0.4%
9	2511	0.4%
B	2346	0.4%
C	2342	0.4%
P	2168	0.4%
M	2039	0.3%
W	1626	0.3%
6	1597	0.3%
Other values (22)	12661	2.1%

City
Categorical

HIGH CARDINALITY
MISSING

Distinct	10931
Distinct (%)	10.3%
Missing	26966
Missing (%)	20.2%
Memory size	1.0 MiB

WILMINGTON	2480
OKLAHOMA CITY	1831
SALT LAKE CITY	1202
WICHITA	1138
DALLAS	967
Other values (10926)	98602

Common Values
Overview

Value	Count	Frequency (%)
WILMINGTON	2480	1.9%
OKLAHOMA CITY	1831	1.4%
SALT LAKE CITY	1202	0.9%
WICHITA	1138	0.9%
DALLAS	967	0.7%
ANCHORAGE	772	0.6%
HOUSTON	603	0.5%
FORT WORTH	598	0.4%
ATLANTA	535	0.4%
MIAMI	479	0.4%
MEMPHIS	472	0.4%
CHICAGO	460	0.3%
PHOENIX	433	0.3%
ALBUQUERQUE	405	0.3%
SEATTLE	374	0.3%
LAS VEGAS	365	0.3%
SAN ANTONIO	357	0.3%
LOUISVILLE	345	0.3%
GROVELAND	335	0.3%
BOISE	307	0.2%
LOS ANGELES	305	0.2%
TUCSON	303	0.2%
PORTLAND	301	0.2%
TULSA	283	0.2%
FAIRBANKS	281	0.2%
Other values (10906)	90289	67.8%
(Missing)	26966	20.2%

Frequencies of value counts

Unique

Unique	3763 ?
Unique (%)	3.5%

Histogram of lengths of the category

Length

Max length	18
Median length	18
Mean length	14.96287898
Min length	3

Overview of Unicode Properties

Unique unicode characters	46
Unique unicode categories	8 ?
Unique unicode scripts	2 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
	1006658	50.5%
A	94464	4.7%
E	85109	4.3%
L	75074	3.8%
O	74567	3.7%
N	72702	3.6%
I	61183	3.1%
R	59080	3.0%
T	55198	2.8%
n	53932	2.7%
S	51125	2.6%
C	32159	1.6%
H	28487	1.4%
D	27582	1.4%
a	26966	1.4%
M	26325	1.3%
G	22906	1.1%
U	20995	1.1%
B	18774	0.9%
W	18688	0.9%
K	16584	0.8%
P	16495	0.8%
Y	15561	0.8%
V	14537	0.7%
F	11226	0.6%
Other values (21)	6469	0.3%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	1006658	50.5%
Uppercase Letter	905171	45.4%
Lowercase Letter	80898	4.1%
Decimal Number	93	< 0.1%
Dash Punctuation	15	< 0.1%
Other Punctuation	9	< 0.1%
Open Punctuation	1	< 0.1%
Close Punctuation	1	< 0.1%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
A	94464	10.4%
E	85109	9.4%
L	75074	8.3%
O	74567	8.2%
N	72702	8.0%
I	61183	6.8%
R	59080	6.5%
T	55198	6.1%
S	51125	5.6%
C	32159	3.6%
H	28487	3.1%
D	27582	3.0%
M	26325	2.9%
G	22906	2.5%
U	20995	2.3%
B	18774	2.1%
W	18688	2.1%
K	16584	1.8%
P	16495	1.8%
Y	15561	1.7%
V	14537	1.6%
F	11226	1.2%
J	2093	0.2%
X	2056	0.2%
Q	1290	0.1%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	1006658	100.0%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
n	53932	66.7%
a	26966	33.3%

Most frequent Dash Punctuation characters

Value	Count	Frequency (%)
-	15	100.0%

Most frequent Other Punctuation characters

Value	Count	Frequency (%)
'	4	44.4%
/	3	33.3%
&	1	11.1%
.	1	11.1%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
1	19	20.4%
2	14	15.1%
0	14	15.1%
5	13	14.0%
3	10	10.8%
9	8	8.6%
6	6	6.5%
4	4	4.3%
7	3	3.2%
8	2	2.2%

Most frequent Open Punctuation characters

Value	Count	Frequency (%)
(	1	100.0%

Most frequent Close Punctuation characters

Value	Count	Frequency (%)
)	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1006777	50.5%
Latin	986069	49.5%

Most frequent Latin characters

Value	Count	Frequency (%)
A	94464	9.6%
E	85109	8.6%
L	75074	7.6%
O	74567	7.6%
N	72702	7.4%
I	61183	6.2%
R	59080	6.0%
T	55198	5.6%
n	53932	5.5%
S	51125	5.2%
C	32159	3.3%
H	28487	2.9%
D	27582	2.8%
a	26966	2.7%
M	26325	2.7%
G	22906	2.3%
U	20995	2.1%
B	18774	1.9%
W	18688	1.9%
K	16584	1.7%
P	16495	1.7%
Y	15561	1.6%
V	14537	1.5%
F	11226	1.1%
J	2093	0.2%
Other values (3)	4257	0.4%

Most frequent Common characters

Value	Count	Frequency (%)
	1006658	> 99.9%
1	19	< 0.1%
-	15	< 0.1%
2	14	< 0.1%
0	14	< 0.1%
5	13	< 0.1%
3	10	< 0.1%
9	8	< 0.1%
6	6	< 0.1%
'	4	< 0.1%
4	4	< 0.1%
7	3	< 0.1%
/	3	< 0.1%
8	2	< 0.1%
&	1	< 0.1%
(	1	< 0.1%
)	1	< 0.1%
.	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1992846	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
	1006658	50.5%
A	94464	4.7%
E	85109	4.3%
L	75074	3.8%
O	74567	3.7%
N	72702	3.6%
I	61183	3.1%
R	59080	3.0%
T	55198	2.8%
n	53932	2.7%
S	51125	2.6%
C	32159	1.6%
H	28487	1.4%
D	27582	1.4%
a	26966	1.4%
M	26325	1.3%
G	22906	1.1%
U	20995	1.1%
B	18774	0.9%
W	18688	0.9%
K	16584	0.8%
P	16495	0.8%
Y	15561	0.8%
V	14537	0.7%
F	11226	0.6%
Other values (21)	6469	0.3%

State
Categorical

HIGH CARDINALITY
HIGH CORRELATION
MISSING

Distinct	58
Distinct (%)	0.1%
Missing	27500
Missing (%)	20.6%
Memory size	1.0 MiB

TX	10003
CA	9529
FL	7912
WA	3769
OK	3361
Other values (53)	71112

Common Values
Overview

Value	Count	Frequency (%)
TX	10003	7.5%
CA	9529	7.2%
FL	7912	5.9%
WA	3769	2.8%
OK	3361	2.5%
DE	3209	2.4%
OH	3075	2.3%
IL	3018	2.3%
MI	2925	2.2%
GA	2868	2.2%
NY	2794	2.1%
AK	2581	1.9%
KS	2520	1.9%
AZ	2485	1.9%
MN	2436	1.8%
PA	2397	1.8%
NC	2381	1.8%
CO	2327	1.7%
OR	2215	1.7%
UT	2097	1.6%
WI	2066	1.6%
TN	2033	1.5%
VA	2018	1.5%
IN	1799	1.4%
MO	1794	1.3%
Other values (33)	22074	16.6%
(Missing)	27500	20.6%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	2
Mean length	2.206478158
Min length	2

Overview of Unicode Properties

Unique unicode characters	26
Unique unicode categories	2 ?
Unique unicode scripts	1 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
n	55000	18.7%
A	31992	10.9%
a	27500	9.4%
N	17149	5.8%
T	16473	5.6%
C	16104	5.5%
L	13863	4.7%
M	13078	4.5%
O	12772	4.3%
I	12681	4.3%
X	10003	3.4%
K	9407	3.2%
F	7912	2.7%
D	6877	2.3%
W	6734	2.3%
S	4782	1.6%
E	4556	1.6%
Y	4253	1.4%
V	4001	1.4%
H	3870	1.3%
R	3516	1.2%
G	2899	1.0%
P	2580	0.9%
Z	2485	0.8%
U	2128	0.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	211372	71.9%
Lowercase Letter	82500	28.1%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
A	31992	15.1%
N	17149	8.1%
T	16473	7.8%
C	16104	7.6%
L	13863	6.6%
M	13078	6.2%
O	12772	6.0%
I	12681	6.0%
X	10003	4.7%
K	9407	4.5%
F	7912	3.7%
D	6877	3.3%
W	6734	3.2%
S	4782	2.3%
E	4556	2.2%
Y	4253	2.0%
V	4001	1.9%
H	3870	1.8%
R	3516	1.7%
G	2899	1.4%
P	2580	1.2%
Z	2485	1.2%
U	2128	1.0%
J	1257	0.6%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
n	55000	66.7%
a	27500	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	293872	100.0%

Most frequent Latin characters

Value	Count	Frequency (%)
n	55000	18.7%
A	31992	10.9%
a	27500	9.4%
N	17149	5.8%
T	16473	5.6%
C	16104	5.5%
L	13863	4.7%
M	13078	4.5%
O	12772	4.3%
I	12681	4.3%
X	10003	3.4%
K	9407	3.2%
F	7912	2.7%
D	6877	2.3%
W	6734	2.3%
S	4782	1.6%
E	4556	1.6%
Y	4253	1.4%
V	4001	1.4%
H	3870	1.3%
R	3516	1.2%
G	2899	1.0%
P	2580	0.9%
Z	2485	0.8%
U	2128	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	293872	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
n	55000	18.7%
A	31992	10.9%
a	27500	9.4%
N	17149	5.8%
T	16473	5.6%
C	16104	5.5%
L	13863	4.7%
M	13078	4.5%
O	12772	4.3%
I	12681	4.3%
X	10003	3.4%
K	9407	3.2%
F	7912	2.7%
D	6877	2.3%
W	6734	2.3%
S	4782	1.6%
E	4556	1.6%
Y	4253	1.4%
V	4001	1.4%
H	3870	1.3%
R	3516	1.2%
G	2899	1.0%
P	2580	0.9%
Z	2485	0.8%
U	2128	0.7%

ZIP
Categorical

HIGH CARDINALITY
MISSING

Distinct	65555
Distinct (%)	61.8%
Missing	27075
Missing (%)	20.3%
Memory size	1.0 MiB

198104902	1038
0	494
672151400	492
841112689	484
731165706	358
Other values (65550)	103245

Common Values
Overview

Value	Count	Frequency (%)
198104902	1038	0.8%
0	494	0.4%
672151400	492	0.4%
841112689	484	0.4%
731165706	358	0.3%
347360368	309	0.2%
198081645	301	0.2%
752351917	283	0.2%
841111346	273	0.2%
84111	236	0.2%
67277	215	0.2%
773602549	209	0.2%
381181547	188	0.1%
303543743	180	0.1%
980572623	179	0.1%
752351908	167	0.1%
402234015	166	0.1%
73125	165	0.1%
199583608	162	0.1%
761552605	157	0.1%
381181516	143	0.1%
329601955	143	0.1%
731026417	140	0.1%
73102	139	0.1%
76155	136	0.1%
Other values (65530)	99354	74.6%
(Missing)	27075	20.3%

Frequencies of value counts

Unique

Unique	53106 ?
Unique (%)	50.0%

Histogram of lengths of the category

Length

Max length	10
Median length	9
Mean length	7.124847957
Min length	1

Overview of Unicode Properties

Unique unicode characters	40
Unique unicode categories	5 ?
Unique unicode scripts	2 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
0	109917	11.6%
1	104751	11.0%
3	92942	9.8%
2	90725	9.6%
4	81944	8.6%
5	81933	8.6%
7	79440	8.4%
9	77617	8.2%
6	73958	7.8%
8	72651	7.7%
n	54150	5.7%
a	27075	2.9%
	886	0.1%
N	321	< 0.1%
R	169	< 0.1%
D	156	< 0.1%
H	34	< 0.1%
A	33	< 0.1%
-	24	< 0.1%
C	22	< 0.1%
L	22	< 0.1%
V	19	< 0.1%
E	19	< 0.1%
G	16	< 0.1%
S	12	< 0.1%
Other values (15)	94	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	865878	91.2%
Lowercase Letter	81225	8.6%
Uppercase Letter	917	0.1%
Space Separator	886	0.1%
Dash Punctuation	24	< 0.1%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
0	109917	12.7%
1	104751	12.1%
3	92942	10.7%
2	90725	10.5%
4	81944	9.5%
5	81933	9.5%
7	79440	9.2%
9	77617	9.0%
6	73958	8.5%
8	72651	8.4%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
n	54150	66.7%
a	27075	33.3%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
N	321	35.0%
R	169	18.4%
D	156	17.0%
H	34	3.7%
A	33	3.6%
C	22	2.4%
L	22	2.4%
V	19	2.1%
E	19	2.1%
G	16	1.7%
S	12	1.3%
J	12	1.3%
W	10	1.1%
P	10	1.1%
K	8	0.9%
Y	8	0.9%
T	7	0.8%
M	7	0.8%
O	7	0.8%
B	6	0.7%
Z	5	0.5%
I	4	0.4%
U	4	0.4%
Q	3	0.3%
X	2	0.2%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	886	100.0%

Most frequent Dash Punctuation characters

Value	Count	Frequency (%)
-	24	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	866788	91.3%
Latin	82142	8.7%

Most frequent Common characters

Value	Count	Frequency (%)
0	109917	12.7%
1	104751	12.1%
3	92942	10.7%
2	90725	10.5%
4	81944	9.5%
5	81933	9.5%
7	79440	9.2%
9	77617	9.0%
6	73958	8.5%
8	72651	8.4%
	886	0.1%
-	24	< 0.1%

Most frequent Latin characters

Value	Count	Frequency (%)
n	54150	65.9%
a	27075	33.0%
N	321	0.4%
R	169	0.2%
D	156	0.2%
H	34	< 0.1%
A	33	< 0.1%
C	22	< 0.1%
L	22	< 0.1%
V	19	< 0.1%
E	19	< 0.1%
G	16	< 0.1%
S	12	< 0.1%
J	12	< 0.1%
W	10	< 0.1%
P	10	< 0.1%
K	8	< 0.1%
Y	8	< 0.1%
T	7	< 0.1%
M	7	< 0.1%
O	7	< 0.1%
B	6	< 0.1%
Z	5	< 0.1%
I	4	< 0.1%
U	4	< 0.1%
Other values (3)	6	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	948930	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
0	109917	11.6%
1	104751	11.0%
3	92942	9.8%
2	90725	9.6%
4	81944	8.6%
5	81933	8.6%
7	79440	8.4%
9	77617	8.2%
6	73958	7.8%
8	72651	7.7%
n	54150	5.7%
a	27075	2.9%
	886	0.1%
N	321	< 0.1%
R	169	< 0.1%
D	156	< 0.1%
H	34	< 0.1%
A	33	< 0.1%
-	24	< 0.1%
C	22	< 0.1%
L	22	< 0.1%
V	19	< 0.1%
E	19	< 0.1%
G	16	< 0.1%
S	12	< 0.1%
Other values (15)	94	< 0.1%

Region
Categorical

HIGH CORRELATION
MISSING

Distinct	10
Distinct (%)	< 0.1%
Missing	26954
Missing (%)	20.2%
Memory size	1.0 MiB

2	17559
C	16625
1	15644
4	13787
7	13480
Other values (5)	29137

Value	Count	Frequency (%)
2	17559	13.2%
C	16625	12.5%
1	15644	11.7%
4	13787	10.4%
7	13480	10.1%
S	13456	10.1%
3	9335	7.0%
E	3406	2.6%
5	2579	1.9%
8	361	0.3%
(Missing)	26954	20.2%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.404757257
Min length	1

Overview of Unicode Properties

Unique unicode characters	12
Unique unicode categories	3 ?
Unique unicode scripts	2 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
n	53908	28.8%
a	26954	14.4%
2	17559	9.4%
C	16625	8.9%
1	15644	8.4%
4	13787	7.4%
7	13480	7.2%
S	13456	7.2%
3	9335	5.0%
E	3406	1.8%
5	2579	1.4%
8	361	0.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	80862	43.2%
Decimal Number	72745	38.9%
Uppercase Letter	33487	17.9%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
C	16625	49.6%
S	13456	40.2%
E	3406	10.2%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
2	17559	24.1%
1	15644	21.5%
4	13787	19.0%
7	13480	18.5%
3	9335	12.8%
5	2579	3.5%
8	361	0.5%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
n	53908	66.7%
a	26954	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	114349	61.1%
Common	72745	38.9%

Most frequent Latin characters

Value	Count	Frequency (%)
n	53908	47.1%
a	26954	23.6%
C	16625	14.5%
S	13456	11.8%
E	3406	3.0%

Most frequent Common characters

Value	Count	Frequency (%)
2	17559	24.1%
1	15644	21.5%
4	13787	19.0%
7	13480	18.5%
3	9335	12.8%
5	2579	3.5%
8	361	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	187094	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
n	53908	28.8%
a	26954	14.4%
2	17559	9.4%
C	16625	8.9%
1	15644	8.4%
4	13787	7.4%
7	13480	7.2%
S	13456	7.2%
3	9335	5.0%
E	3406	1.8%
5	2579	1.4%
8	361	0.2%

County
Real number (ℝ_≥0)

MISSING

Distinct	324
Distinct (%)	0.3%
Missing	27669
Missing (%)	20.8%
Infinite	0
Infinite (%)	0.0%

Mean	90.54160941
Minimum	0
Maximum	999
Zeros	119
Zeros (%)	0.1%
Memory size	1.0 MiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	27
median	63
Q3	113
95-th percentile	291
Maximum	999
Range	999
Interquartile range (IQR)	86

Descriptive statistics

Standard deviation	105.2836205
Coefficient of variation (CV)	1.16282029
Kurtosis	11.88840334
Mean	90.54160941
Median Absolute Deviation (MAD)	44
Skewness	2.99174998
Sum	9553679
Variance	11084.64074
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	5018	3.8%
13	2835	2.1%
1	2808	2.1%
37	2755	2.1%
109	2597	1.9%
35	2554	1.9%
31	2498	1.9%
113	2098	1.6%
5	1975	1.5%
25	1954	1.5%
33	1941	1.5%
29	1875	1.4%
11	1865	1.4%
19	1665	1.3%
61	1617	1.2%
73	1572	1.2%
17	1541	1.2%
9	1522	1.1%
59	1438	1.1%
53	1434	1.1%
173	1325	1.0%
111	1309	1.0%
67	1294	1.0%
27	1287	1.0%
85	1271	1.0%
Other values (299)	55469	41.6%
(Missing)	27669	20.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	119	0.1%
1	2808	2.1%
2	1	< 0.1%
3	5018	3.8%
4	4	< 0.1%
5	1975	1.5%
6	9	< 0.1%
7	934	0.7%
9	1522	1.1%
10	7	< 0.1%

Value	Count	Frequency (%)
999	2	< 0.1%
840	24	< 0.1%
830	36	< 0.1%
820	5	< 0.1%
810	108	0.1%
800	12	< 0.1%
790	6	< 0.1%
775	11	< 0.1%
770	30	< 0.1%
760	90	0.1%

Country
Categorical

HIGH CARDINALITY
HIGH CORRELATION
MISSING

Distinct	62
Distinct (%)	0.1%
Missing	26967
Missing (%)	20.2%
Memory size	1.0 MiB

US	105434
GB	184
RQ	173
DE	50
VI	47
Other values (57)	331

Common Values
Overview

Value	Count	Frequency (%)
US	105434	79.2%
GB	184	0.1%
RQ	173	0.1%
DE	50	< 0.1%
VI	47	< 0.1%
CA	40	< 0.1%
GU	31	< 0.1%
CH	27	< 0.1%
FR	21	< 0.1%
AU	18	< 0.1%
VU	16	< 0.1%
AT	13	< 0.1%
PH	12	< 0.1%
SA	11	< 0.1%
NL	10	< 0.1%
MX	10	< 0.1%
NZ	9	< 0.1%
HK	8	< 0.1%
SG	7	< 0.1%
BS	7	< 0.1%
CO	6	< 0.1%
IE	6	< 0.1%
BE	6	< 0.1%
MP	5	< 0.1%
JP	4	< 0.1%
Other values (37)	64	< 0.1%
(Missing)	26967	20.2%

Frequencies of value counts

Unique

Unique	20 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	2
Mean length	2.202476236
Min length	2

Overview of Unicode Properties

Unique unicode characters	27
Unique unicode categories	2 ?
Unique unicode scripts	1 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
U	105502	36.0%
S	105462	36.0%
n	53934	18.4%
a	26967	9.2%
G	226	0.1%
R	205	0.1%
B	201	0.1%
Q	175	0.1%
A	94	< 0.1%
C	78	< 0.1%
E	69	< 0.1%
V	67	< 0.1%
H	59	< 0.1%
I	54	< 0.1%
D	53	< 0.1%
N	29	< 0.1%
P	29	< 0.1%
T	23	< 0.1%
F	22	< 0.1%
M	20	< 0.1%
K	15	< 0.1%
L	14	< 0.1%
Z	12	< 0.1%
O	11	< 0.1%
X	10	< 0.1%
Other values (2)	8	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	212438	72.4%
Lowercase Letter	80901	27.6%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
U	105502	49.7%
S	105462	49.6%
G	226	0.1%
R	205	0.1%
B	201	0.1%
Q	175	0.1%
A	94	< 0.1%
C	78	< 0.1%
E	69	< 0.1%
V	67	< 0.1%
H	59	< 0.1%
I	54	< 0.1%
D	53	< 0.1%
N	29	< 0.1%
P	29	< 0.1%
T	23	< 0.1%
F	22	< 0.1%
M	20	< 0.1%
K	15	< 0.1%
L	14	< 0.1%
Z	12	< 0.1%
O	11	< 0.1%
X	10	< 0.1%
J	5	< 0.1%
Y	3	< 0.1%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
n	53934	66.7%
a	26967	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	293339	100.0%

Most frequent Latin characters

Value	Count	Frequency (%)
U	105502	36.0%
S	105462	36.0%
n	53934	18.4%
a	26967	9.2%
G	226	0.1%
R	205	0.1%
B	201	0.1%
Q	175	0.1%
A	94	< 0.1%
C	78	< 0.1%
E	69	< 0.1%
V	67	< 0.1%
H	59	< 0.1%
I	54	< 0.1%
D	53	< 0.1%
N	29	< 0.1%
P	29	< 0.1%
T	23	< 0.1%
F	22	< 0.1%
M	20	< 0.1%
K	15	< 0.1%
L	14	< 0.1%
Z	12	< 0.1%
O	11	< 0.1%
X	10	< 0.1%
Other values (2)	8	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	293339	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
U	105502	36.0%
S	105462	36.0%
n	53934	18.4%
a	26967	9.2%
G	226	0.1%
R	205	0.1%
B	201	0.1%
Q	175	0.1%
A	94	< 0.1%
C	78	< 0.1%
E	69	< 0.1%
V	67	< 0.1%
H	59	< 0.1%
I	54	< 0.1%
D	53	< 0.1%
N	29	< 0.1%
P	29	< 0.1%
T	23	< 0.1%
F	22	< 0.1%
M	20	< 0.1%
K	15	< 0.1%
L	14	< 0.1%
Z	12	< 0.1%
O	11	< 0.1%
X	10	< 0.1%
Other values (2)	8	< 0.1%

Last Activity Date
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	2620
Distinct (%)	2.9%
Missing	43927
Missing (%)	33.0%
Infinite	0
Infinite (%)	0.0%

Mean	20119973.32
Minimum	19720113
Maximum	20161229
Zeros	0
Zeros (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	19720113
5-th percentile	19770114
Q1	20140807
median	20150624
Q3	20160412
95-th percentile	20161118
Maximum	20161229
Range	441116
Interquartile range (IQR)	19605

Descriptive statistics

Standard deviation	102396.0033
Coefficient of variation (CV)	0.005089271324
Kurtosis	7.540917239
Mean	20119973.32
Median Absolute Deviation (MAD)	9809
Skewness	-3.060234901
Sum	1.795888699e+12
Variance	1.048494148e+10
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19770114	6060	4.6%
20161212	311	0.2%
20150511	287	0.2%
20150811	286	0.2%
20150512	280	0.2%
20140811	267	0.2%
20140812	262	0.2%
20161213	260	0.2%
20161108	259	0.2%
20161115	254	0.2%
20161114	253	0.2%
20161116	245	0.2%
20150608	240	0.2%
20140512	236	0.2%
20151110	232	0.2%
20160510	229	0.2%
20160809	228	0.2%
20150609	223	0.2%
20161214	221	0.2%
20150812	221	0.2%
20151109	220	0.2%
20161012	216	0.2%
20150810	212	0.2%
20161109	212	0.2%
20140513	207	0.2%
Other values (2595)	77338	58.1%
(Missing)	43927	33.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
19720113	1	< 0.1%
19720525	1	< 0.1%
19770114	6060	4.6%
19770115	3	< 0.1%
19770122	10	< 0.1%
19770129	3	< 0.1%
19770213	20	< 0.1%
19770219	26	< 0.1%
19770222	25	< 0.1%
19770305	23	< 0.1%

Value	Count	Frequency (%)
20161229	117	0.1%
20161228	123	0.1%
20161227	85	0.1%
20161226	19	< 0.1%
20161225	7	< 0.1%
20161224	12	< 0.1%
20161223	72	0.1%
20161222	153	0.1%
20161221	192	0.1%
20161220	67	0.1%

Cert Issue Date
Real number (ℝ_≥0)

MISSING

Distinct	11502
Distinct (%)	14.1%
Missing	51433
Missing (%)	38.6%
Infinite	0
Infinite (%)	0.0%

Mean	20058882.07
Minimum	19460529
Maximum	20161229
Zeros	0
Zeros (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	19460529
5-th percentile	19790417.2
Q1	20010828
median	20110512
Q3	20150319
95-th percentile	20160915
Maximum	20161229
Range	700700
Interquartile range (IQR)	139491

Descriptive statistics

Standard deviation	118823.3645
Coefficient of variation (CV)	0.005923728155
Kurtosis	1.630621884
Mean	20058882.07
Median Absolute Deviation (MAD)	40692
Skewness	-1.497833427
Sum	1.639873786e+12
Variance	1.411899195e+10
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20161212	99	0.1%
20151205	98	0.1%
20151212	94	0.1%
20161031	91	0.1%
20151007	91	0.1%
20151219	88	0.1%
20150630	84	0.1%
20161221	83	0.1%
20160920	81	0.1%
20161020	81	0.1%
20161019	80	0.1%
20151005	80	0.1%
20150817	80	0.1%
20161101	77	0.1%
20150720	77	0.1%
20151130	76	0.1%
20151230	76	0.1%
20161018	76	0.1%
20151203	74	0.1%
20150727	74	0.1%
20130401	74	0.1%
20161214	74	0.1%
20160107	73	0.1%
20151210	73	0.1%
20161213	73	0.1%
Other values (11477)	79726	59.9%
(Missing)	51433	38.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
19460529	1	< 0.1%
19460726	1	< 0.1%
19460905	1	< 0.1%
19470521	1	< 0.1%
19470924	1	< 0.1%
19471003	1	< 0.1%
19471211	1	< 0.1%
19471230	1	< 0.1%
19480319	1	< 0.1%
19490425	1	< 0.1%

Value	Count	Frequency (%)
20161229	38	< 0.1%
20161228	65	< 0.1%
20161227	40	< 0.1%
20161223	32	< 0.1%
20161222	71	0.1%
20161221	83	0.1%
20161220	18	< 0.1%
20161219	57	< 0.1%
20161216	59	< 0.1%
20161215	38	< 0.1%

Certification Requested
Categorical

HIGH CARDINALITY
MISSING

Distinct	181
Distinct (%)	0.2%
Missing	55743
Missing (%)	41.9%
Memory size	1.0 MiB

1N	22936
1	18090
1NU	8305
42	8245
1U	4612
Other values (176)	15255

Common Values
Overview

Value	Count	Frequency (%)
1N	22936	17.2%
1	18090	13.6%
1NU	8305	6.2%
42	8245	6.2%
1U	4612	3.5%
1T	4194	3.1%
31	1559	1.2%
48A	1371	1.0%
1B	1348	1.0%
43	1046	0.8%
1NA	740	0.6%
9A	585	0.4%
1G	481	0.4%
6131	386	0.3%
1A	343	0.3%
1C	343	0.3%
41	238	0.2%
314	223	0.2%
40	174	0.1%
443	172	0.1%
30	166	0.1%
434	138	0.1%
6130	135	0.1%
48B	129	0.1%
2	107	0.1%
Other values (156)	1377	1.0%
(Missing)	55743	41.9%

Frequencies of value counts

Unique

Unique	70 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	10
Median length	3
Mean length	5.049419609
Min length	1

Overview of Unicode Properties

Unique unicode characters	23
Unique unicode categories	4 ?
Unique unicode scripts	2 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
	355108	52.8%
n	111486	16.6%
1	64991	9.7%
a	55743	8.3%
N	32050	4.8%
U	13013	1.9%
4	12787	1.9%
2	8568	1.3%
3	4663	0.7%
T	4196	0.6%
A	3143	0.5%
8	1695	0.3%
B	1494	0.2%
6	930	0.1%
9	746	0.1%
0	660	0.1%
G	531	0.1%
C	463	0.1%
5	122	< 0.1%
W	55	< 0.1%
7	25	< 0.1%
O	23	< 0.1%
P	20	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Space Separator	355108	52.8%
Lowercase Letter	167229	24.9%
Decimal Number	95187	14.2%
Uppercase Letter	54988	8.2%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
1	64991	68.3%
4	12787	13.4%
2	8568	9.0%
3	4663	4.9%
8	1695	1.8%
6	930	1.0%
9	746	0.8%
0	660	0.7%
5	122	0.1%
7	25	< 0.1%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
N	32050	58.3%
U	13013	23.7%
T	4196	7.6%
A	3143	5.7%
B	1494	2.7%
G	531	1.0%
C	463	0.8%
W	55	0.1%
O	23	< 0.1%
P	20	< 0.1%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	355108	100.0%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
n	111486	66.7%
a	55743	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	450295	67.0%
Latin	222217	33.0%

Most frequent Common characters

Value	Count	Frequency (%)
	355108	78.9%
1	64991	14.4%
4	12787	2.8%
2	8568	1.9%
3	4663	1.0%
8	1695	0.4%
6	930	0.2%
9	746	0.2%
0	660	0.1%
5	122	< 0.1%
7	25	< 0.1%

Most frequent Latin characters

Value	Count	Frequency (%)
n	111486	50.2%
a	55743	25.1%
N	32050	14.4%
U	13013	5.9%
T	4196	1.9%
A	3143	1.4%
B	1494	0.7%
G	531	0.2%
C	463	0.2%
W	55	< 0.1%
O	23	< 0.1%
P	20	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	672512	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
	355108	52.8%
n	111486	16.6%
1	64991	9.7%
a	55743	8.3%
N	32050	4.8%
U	13013	1.9%
4	12787	1.9%
2	8568	1.3%
3	4663	0.7%
T	4196	0.6%
A	3143	0.5%
8	1695	0.3%
B	1494	0.2%
6	930	0.1%
9	746	0.1%
0	660	0.1%
G	531	0.1%
C	463	0.1%
5	122	< 0.1%
W	55	< 0.1%
7	25	< 0.1%
O	23	< 0.1%
P	20	< 0.1%

Type Aircraft
Real number (ℝ_≥0)

MISSING

Distinct	9
Distinct (%)	< 0.1%
Missing	43927
Missing (%)	33.0%
Infinite	0
Infinite (%)	0.0%

Mean	4.23736542
Minimum	1
Maximum	9
Zeros	0
Zeros (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	4
median	4
Q3	4
95-th percentile	6
Maximum	9
Range	8
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.9019209575
Coefficient of variation (CV)	0.2128494638
Kurtosis	5.502488415
Mean	4.23736542
Median Absolute Deviation (MAD)	0
Skewness	0.3155437799
Sum	378223
Variance	0.8134614136
Monotocity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
4	66483	49.9%
5	11166	8.4%
6	7128	5.4%
2	1699	1.3%
1	1667	1.3%
8	652	0.5%
7	352	0.3%
9	102	0.1%
3	10	< 0.1%
(Missing)	43927	33.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1667	1.3%
2	1699	1.3%
3	10	< 0.1%
4	66483	49.9%
5	11166	8.4%
6	7128	5.4%
7	352	0.3%
8	652	0.5%
9	102	0.1%

Value	Count	Frequency (%)
9	102	0.1%
8	652	0.5%
7	352	0.3%
6	7128	5.4%
5	11166	8.4%
4	66483	49.9%
3	10	< 0.1%
2	1699	1.3%
1	1667	1.3%

Type Engine
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	12
Distinct (%)	< 0.1%
Missing	43927
Missing (%)	33.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.126452235
Minimum	0
Maximum	11
Zeros	3100
Zeros (%)	2.3%
Memory size	1.0 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	8
Maximum	11
Range	11
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.516458035
Coefficient of variation (CV)	1.183406801
Kurtosis	2.73325513
Mean	2.126452235
Median Absolute Deviation (MAD)	0
Skewness	2.016392545
Sum	189805
Variance	6.332561044
Monotocity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	65978	49.5%
8	4907	3.7%
5	4832	3.6%
10	3404	2.6%
0	3100	2.3%
2	2643	2.0%
3	1950	1.5%
7	1785	1.3%
4	644	0.5%
11	13	< 0.1%
6	2	< 0.1%
9	1	< 0.1%
(Missing)	43927	33.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	3100	2.3%
1	65978	49.5%
2	2643	2.0%
3	1950	1.5%
4	644	0.5%
5	4832	3.6%
6	2	< 0.1%
7	1785	1.3%
8	4907	3.7%
9	1	< 0.1%

Value	Count	Frequency (%)
11	13	< 0.1%
10	3404	2.6%
9	1	< 0.1%
8	4907	3.7%
7	1785	1.3%
6	2	< 0.1%
5	4832	3.6%
4	644	0.5%
3	1950	1.5%
2	2643	2.0%

Status Code
Categorical

Distinct	26
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	1.0 MiB

V	72794
5	43869
9	5242
28	3138
25	2964
Other values (21)	5178

Common Values
Overview

Value	Count	Frequency (%)
V	72794	54.7%
5	43869	32.9%
9	5242	3.9%
28	3138	2.4%
25	2964	2.2%
21	1399	1.1%
24	850	0.6%
7	835	0.6%
R	768	0.6%
26	474	0.4%
M	374	0.3%
27	126	0.1%
2	105	0.1%
Z	57	< 0.1%
17	50	< 0.1%
10	45	< 0.1%
3	31	< 0.1%
4	19	< 0.1%
19	13	< 0.1%
11	12	< 0.1%
23	6	< 0.1%
12	6	< 0.1%
N	5	< 0.1%
D	1	< 0.1%
W	1	< 0.1%

Frequencies of value counts

Unique

Unique	3 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	2
Mean length	1.623834337
Min length	1

Overview of Unicode Properties

Unique unicode characters	20
Unique unicode categories	4 ?
Unique unicode scripts	2 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
	74000	34.2%
V	72794	33.7%
5	46833	21.7%
2	9070	4.2%
9	5255	2.4%
8	3138	1.5%
1	1537	0.7%
7	1011	0.5%
4	869	0.4%
R	768	0.4%
6	474	0.2%
M	374	0.2%
Z	57	< 0.1%
0	45	< 0.1%
3	37	< 0.1%
N	5	< 0.1%
n	2	< 0.1%
D	1	< 0.1%
W	1	< 0.1%
a	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	74000	34.2%
Space Separator	74000	34.2%
Decimal Number	68269	31.6%
Lowercase Letter	3	< 0.1%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
V	72794	98.4%
R	768	1.0%
M	374	0.5%
Z	57	0.1%
N	5	< 0.1%
D	1	< 0.1%
W	1	< 0.1%

Most frequent Space Separator characters

Value	Count	Frequency (%)
	74000	100.0%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
5	46833	68.6%
2	9070	13.3%
9	5255	7.7%
8	3138	4.6%
1	1537	2.3%
7	1011	1.5%
4	869	1.3%
6	474	0.7%
0	45	0.1%
3	37	0.1%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
n	2	66.7%
a	1	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	142269	65.8%
Latin	74003	34.2%

Most frequent Latin characters

Value	Count	Frequency (%)
V	72794	98.4%
R	768	1.0%
M	374	0.5%
Z	57	0.1%
N	5	< 0.1%
n	2	< 0.1%
D	1	< 0.1%
W	1	< 0.1%
a	1	< 0.1%

Most frequent Common characters

Value	Count	Frequency (%)
	74000	52.0%
5	46833	32.9%
2	9070	6.4%
9	5255	3.7%
8	3138	2.2%
1	1537	1.1%
7	1011	0.7%
4	869	0.6%
6	474	0.3%
0	45	< 0.1%
3	37	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	216272	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
	74000	34.2%
V	72794	33.7%
5	46833	21.7%
2	9070	4.2%
9	5255	2.4%
8	3138	1.5%
1	1537	0.7%
7	1011	0.5%
4	869	0.4%
R	768	0.4%
6	474	0.2%
M	374	0.2%
Z	57	< 0.1%
0	45	< 0.1%
3	37	< 0.1%
N	5	< 0.1%
n	2	< 0.1%
D	1	< 0.1%
W	1	< 0.1%
a	1	< 0.1%

Mode S Code
Real number (ℝ_≥0)

Distinct	133185
Distinct (%)	100.0%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%

Mean	51554648.14
Minimum	50000010
Maximum	53373705
Zeros	0
Zeros (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	50000010
5-th percentile	50105037
Q1	50606413
median	51477722
Q3	52415661
95-th percentile	53215372.4
Maximum	53373705
Range	3373695
Interquartile range (IQR)	1809248

Descriptive statistics

Standard deviation	1010772.145
Coefficient of variation (CV)	0.01960583927
Kurtosis	-1.228389791
Mean	51554648.14
Median Absolute Deviation (MAD)	906307
Skewness	0.1293381853
Sum	6.866305813e+12
Variance	1.021660329e+12
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
50000013	1	< 0.1%
52526174	1	< 0.1%
51720742	1	< 0.1%
53163320	1	< 0.1%
53162732	1	< 0.1%
53163461	1	< 0.1%
53163707	1	< 0.1%
53163012	1	< 0.1%
50557540	1	< 0.1%
50554160	1	< 0.1%
50555741	1	< 0.1%
50554070	1	< 0.1%
50534356	1	< 0.1%
50215652	1	< 0.1%
51636046	1	< 0.1%
52637720	1	< 0.1%
53103753	1	< 0.1%
50154430	1	< 0.1%
52533370	1	< 0.1%
51102101	1	< 0.1%
52017427	1	< 0.1%
50556020	1	< 0.1%
51456266	1	< 0.1%
50712720	1	< 0.1%
52637664	1	< 0.1%
Other values (133160)	133160	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
50000010	1	< 0.1%
50000012	1	< 0.1%
50000013	1	< 0.1%
50000021	1	< 0.1%
50000033	1	< 0.1%
50000035	1	< 0.1%
50000036	1	< 0.1%
50000041	1	< 0.1%
50000043	1	< 0.1%
50000044	1	< 0.1%

Value	Count	Frequency (%)
53373705	1	< 0.1%
53373670	1	< 0.1%
53373663	1	< 0.1%
53373660	1	< 0.1%
53373652	1	< 0.1%
53373651	1	< 0.1%
53373650	1	< 0.1%
53373647	1	< 0.1%
53373644	1	< 0.1%
53373643	1	< 0.1%

Fractional Ownership
Categorical

MISSING

Distinct	1
Distinct (%)	4.8%
Missing	133165
Missing (%)	> 99.9%
Memory size	1.0 MiB

Y	21

Value	Count	Frequency (%)
Y	21	< 0.1%
(Missing)	133165	> 99.9%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	3
Mean length	2.999684652
Min length	1

Overview of Unicode Properties

Unique unicode characters	3
Unique unicode categories	2 ?
Unique unicode scripts	1 ?
Unique unicode blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
n	266330	66.7%
a	133165	33.3%
Y	21	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	399495	> 99.9%
Uppercase Letter	21	< 0.1%

Most frequent Lowercase Letter characters

Value	Count	Frequency (%)
n	266330	66.7%
a	133165	33.3%

Most frequent Uppercase Letter characters

Value	Count	Frequency (%)
Y	21	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	399516	100.0%

Most frequent Latin characters

Value	Count	Frequency (%)
n	266330	66.7%
a	133165	33.3%
Y	21	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	399516	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
n	266330	66.7%
a	133165	33.3%
Y	21	< 0.1%

Airworthiness Date
Real number (ℝ_≥0)

MISSING

Distinct	17390
Distinct (%)	24.7%
Missing	62700
Missing (%)	47.1%
Infinite	0
Infinite (%)	0.0%

Mean	19822614.69
Minimum	19000217
Maximum	20161203
Zeros	0
Zeros (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	19000217
5-th percentile	19560308
Q1	19660422
median	19781003
Q3	20010924
95-th percentile	20150528
Maximum	20161203
Range	1160986
Interquartile range (IQR)	350502

Descriptive statistics

Standard deviation	195610.504
Coefficient of variation (CV)	0.009868047534
Kurtosis	-1.233144776
Mean	19822614.69
Median Absolute Deviation (MAD)	169307
Skewness	0.256651657
Sum	1.397216819e+12
Variance	3.826346926e+10
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19560716	140	0.1%
19560714	89	0.1%
19611024	50	< 0.1%
19560715	50	< 0.1%
19790815	49	< 0.1%
19591027	48	< 0.1%
19601031	48	< 0.1%
19560505	46	< 0.1%
19560712	46	< 0.1%
19560629	45	< 0.1%
19560711	44	< 0.1%
19560710	43	< 0.1%
19560630	43	< 0.1%
19791112	40	< 0.1%
19560526	40	< 0.1%
19560713	40	< 0.1%
19560616	40	< 0.1%
19560512	38	< 0.1%
19560707	38	< 0.1%
19560525	38	< 0.1%
19560323	37	< 0.1%
19560519	36	< 0.1%
19560706	36	< 0.1%
19560628	35	< 0.1%
19560406	35	< 0.1%
Other values (17365)	69292	52.0%
(Missing)	62700	47.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
19000217	1	< 0.1%
19161104	1	< 0.1%
19220707	1	< 0.1%
19270525	1	< 0.1%
19290812	1	< 0.1%
19310629	1	< 0.1%
19320314	1	< 0.1%
19351112	1	< 0.1%
19360105	1	< 0.1%
19360421	1	< 0.1%

Value	Count	Frequency (%)
20161203	1	< 0.1%
20161201	3	< 0.1%
20161130	3	< 0.1%
20161129	1	< 0.1%
20161128	2	< 0.1%
20161126	1	< 0.1%
20161123	3	< 0.1%
20161122	1	< 0.1%
20161121	3	< 0.1%
20161120	2	< 0.1%

Other Name 1
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	133186
Missing (%)	100.0%
Memory size	1.0 MiB

Other Name 2
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	133186
Missing (%)	100.0%
Memory size	1.0 MiB

Other Name 3
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	133186
Missing (%)	100.0%
Memory size	1.0 MiB

Other Name 4
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	133186
Missing (%)	100.0%
Memory size	1.0 MiB

Other Name 5
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	133186
Missing (%)	100.0%
Memory size	1.0 MiB

Expiration Date
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	549
Distinct (%)	0.6%
Missing	36507
Missing (%)	27.4%
Infinite	0
Infinite (%)	0.0%

Mean	22309406
Minimum	19790911
Maximum	99999999
Zeros	0
Zeros (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	19790911
5-th percentile	20160916.9
Q1	20170831
median	20180731
Q3	20190531
95-th percentile	20200331
Maximum	99999999
Range	80209088
Interquartile range (IQR)	19700

Descriptive statistics

Standard deviation	12864361.91
Coefficient of variation (CV)	0.576633995
Kurtosis	32.50157035
Mean	22309406
Median Absolute Deviation (MAD)	9822
Skewness	5.873743209
Sum	2.156851063e+12
Variance	1.654918073e+14
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20180430	3281	2.5%
20181031	3252	2.4%
20180731	3139	2.4%
20180131	3061	2.3%
20190131	3056	2.3%
20191031	2652	2.0%
99999999	2580	1.9%
20190731	2545	1.9%
20180831	2490	1.9%
20190430	2420	1.8%
20171031	2400	1.8%
20170731	2382	1.8%
20181231	2199	1.7%
20191130	2190	1.6%
20200131	2114	1.6%
20191231	2102	1.6%
20180630	2010	1.5%
20181130	1998	1.5%
20180228	1971	1.5%
20180531	1954	1.5%
20180930	1949	1.5%
20180331	1940	1.5%
20190930	1914	1.4%
20190831	1839	1.4%
20170831	1742	1.3%
Other values (524)	37499	28.2%
(Missing)	36507	27.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
19790911	1	< 0.1%
19791228	1	< 0.1%
19870301	1	< 0.1%
19870608	1	< 0.1%
19880202	2	< 0.1%
19891119	1	< 0.1%
19910805	1	< 0.1%
19940125	2	< 0.1%
19980226	1	< 0.1%
20110331	46	< 0.1%

Value	Count	Frequency (%)
99999999	2580	1.9%
20200531	549	0.4%
20200430	1603	1.2%
20200331	920	0.7%
20200229	800	0.6%
20200131	2114	1.6%
20191231	2102	1.6%
20191130	2190	1.6%
20191031	2652	2.0%
20190930	1914	1.4%

Unique ID
Real number (ℝ_≥0)

MISSING

Distinct	89259
Distinct (%)	100.0%
Missing	43927
Missing (%)	33.0%
Infinite	0
Infinite (%)	0.0%

Mean	540455.812
Minimum	2
Maximum	1239445
Zeros	0
Zeros (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	2
5-th percentile	44017
Q1	230553
median	469659
Q3	841356.5
95-th percentile	1190761.2
Maximum	1239445
Range	1239443
Interquartile range (IQR)	610803.5

Descriptive statistics

Standard deviation	365580.0503
Coefficient of variation (CV)	0.6764291218
Kurtosis	-1.071898284
Mean	540455.812
Median Absolute Deviation (MAD)	290608
Skewness	0.3660445438
Sum	4.824054533e+10
Variance	1.336487732e+11
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
90000	1	< 0.1%
30301	1	< 0.1%
860301	1	< 0.1%
772711	1	< 0.1%
314080	1	< 0.1%
104559	1	< 0.1%
290055	1	< 0.1%
300301	1	< 0.1%
243439	1	< 0.1%
135772	1	< 0.1%
40301	1	< 0.1%
384778	1	< 0.1%
360108	1	< 0.1%
360098	1	< 0.1%
360068	1	< 0.1%
340341	1	< 0.1%
141815	1	< 0.1%
363816	1	< 0.1%
360038	1	< 0.1%
360008	1	< 0.1%
850281	1	< 0.1%
60291	1	< 0.1%
890331	1	< 0.1%
1220388	1	< 0.1%
60281	1	< 0.1%
Other values (89234)	89234	67.0%
(Missing)	43927	33.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	1	< 0.1%
4	1	< 0.1%
16	1	< 0.1%
20	1	< 0.1%
23	1	< 0.1%
24	1	< 0.1%
31	1	< 0.1%
42	1	< 0.1%
44	1	< 0.1%
46	1	< 0.1%

Value	Count	Frequency (%)
1239445	1	< 0.1%
1239444	1	< 0.1%
1239404	1	< 0.1%
1239400	1	< 0.1%
1239384	1	< 0.1%
1239271	1	< 0.1%
1239267	1	< 0.1%
1239232	1	< 0.1%
1239208	1	< 0.1%
1239139	1	< 0.1%

Kit MFR Code
Real number (ℝ_≥0)

MISSING

Distinct	580
Distinct (%)	17.9%
Missing	129937
Missing (%)	97.6%
Infinite	0
Infinite (%)	0.0%

Mean	452.511542
Minimum	4
Maximum	1268
Zeros	0
Zeros (%)	0.0%
Memory size	1.0 MiB

Quantile statistics

Minimum	4
5-th percentile	113
Q1	157
median	368
Q3	660
95-th percentile	1121
Maximum	1268
Range	1264
Interquartile range (IQR)	503

Descriptive statistics

Standard deviation	332.9188498
Coefficient of variation (CV)	0.7357134987
Kurtosis	-0.4387089769
Mean	452.511542
Median Absolute Deviation (MAD)	211
Skewness	0.8482174665
Sum	1470210
Variance	110834.9605
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
157	228	0.2%
462	158	0.1%
344	141	0.1%
153	137	0.1%
403	134	0.1%
155	132	0.1%
540	114	0.1%
179	87	0.1%
152	85	0.1%
158	71	0.1%
113	50	< 0.1%
202	44	< 0.1%
178	42	< 0.1%
760	42	< 0.1%
847	41	< 0.1%
559	37	< 0.1%
182	32	< 0.1%
227	31	< 0.1%
1184	29	< 0.1%
672	26	< 0.1%
455	22	< 0.1%
904	17	< 0.1%
1083	16	< 0.1%
369	16	< 0.1%
976	16	< 0.1%
Other values (555)	1501	1.1%
(Missing)	129937	97.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4	1	< 0.1%
6	3	< 0.1%
9	4	< 0.1%
16	4	< 0.1%
19	1	< 0.1%
20	2	< 0.1%
21	3	< 0.1%
27	2	< 0.1%
29	2	< 0.1%
30	4	< 0.1%

Value	Count	Frequency (%)
1268	1	< 0.1%
1267	1	< 0.1%
1266	2	< 0.1%
1265	1	< 0.1%
1264	1	< 0.1%
1263	4	< 0.1%
1261	2	< 0.1%
1260	2	< 0.1%
1256	2	< 0.1%
1255	1	< 0.1%

Kit Model
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	133186
Missing (%)	100.0%
Memory size	1.0 MiB

Mose S Code Hex
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	133186
Missing (%)	100.0%
Memory size	1.0 MiB

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	N-Number	Serial Number	MFR MDL Code	Eng MFR Code	Year MFR	Type Registrant	Name	Street 1	Street2	City	State	ZIP	Region	County	Country	Last Activity Date	Cert Issue Date	Certification Requested	Type Aircraft	Type Engine	Status Code	Mode S Code	Fractional Ownership	Airworthiness Date	Other Name 1	Other Name 2	Other Name 3	Other Name 4	Other Name 5	Expiration Date	Unique ID	Kit MFR Code	Kit Model	Mose S Code Hex
0	1AJ	156H	7220282	41514.0	1973.0	NaN	JENKINS ARTHUR J	PO BOX 129	NaN	KILA	MT	599200129	S	29.0	US	20141105.0	19730815.0	42	4.0	1.0	V	50000013.0	NaN	19791004.0	NaN	NaN	NaN	NaN	NaN	20180331.0	90000.0	NaN	NaN	NaN
1	7D	D-1	4970150	41508.0	1951.0	NaN	HOLLIDAY MARK E	PO BOX 243	NaN	LAKE ELMO	MN	550420243	C	163.0	US	20131127.0	20110401.0	42	4.0	1.0	25	52250047.0	NaN	20110811.0	NaN	NaN	NaN	NaN	NaN	20170430.0	300000.0	NaN	NaN	NaN
2	1BH	1951034	13007S6	43101.0	1972.0	NaN	HINSON BOBBY W	PO BOX 988	NaN	LANCASTER	SC	297210988	7	57.0	US	20140227.0	19720404.0	42	6.0	1.0	25	50000043.0	NaN	19740920.0	NaN	NaN	NaN	NaN	NaN	20170430.0	240000.0	NaN	NaN	NaN
3	721NM	11E-1001	7320100	17160.0	2008.0	NaN	ORACLE AVIATION LLC	12916 MILLARD AIRPORT PLZ	NaN	OMAHA	NE	681374260	3	55.0	US	20160830.0	20160830.0	1N	4.0	1.0	V	52324173.0	NaN	20160624.0	NaN	NaN	NaN	NaN	NaN	20190831.0	389719.0	NaN	NaN	NaN
4	6334	NaN	NaN	NaN	NaN	NaN	NIEUPORT LLC	20406 FORTUNES WAY	NaN	REMINGTON	VA	227341716	1	61.0	US	NaN	NaN	NaN	NaN	NaN	5	52045705.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	20170903.0	NaN	NaN	NaN	NaN
5	262AA	NaN	NaN	NaN	NaN	NaN	CANCELLED/NOT ASSIGNED	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	50503154.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
6	33HF	NaN	NaN	NaN	NaN	NaN	BERRYHILL RYAN	5241 KIRKSIDE CV	NaN	MEMPHIS	TN	381174562	3	157.0	US	NaN	NaN	NaN	NaN	NaN	5	50712053.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	20160903.0	NaN	NaN	NaN	NaN
7	458TL	NaN	NaN	NaN	NaN	NaN	CANCELLED/NOT ASSIGNED	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	51310610.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
8	528KP	PV-1402	061003Z	NaN	NaN	NaN	PICTORVISION INC	16238 RAYMER ST	NaN	VAN NUYS	CA	914061209	4	37.0	US	20141107.0	20141107.0	NaN	6.0	10.0	V	51523625.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	20171130.0	1164358.0	NaN	NaN	NaN
9	141BG	14001	05633XW	NaN	NaN	NaN	HEINITZ BRADFORD C	31925 369TH AVE NE	NaN	ARLINGTON	WA	982235658	S	61.0	US	20141103.0	20141103.0	NaN	6.0	7.0	V	50123207.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	20171130.0	1164360.0	NaN	NaN	NaN

Last rows

	N-Number	Serial Number	MFR MDL Code	Eng MFR Code	Year MFR	Type Registrant	Name	Street 1	Street2	City	State	ZIP	Region	County	Country	Last Activity Date	Cert Issue Date	Certification Requested	Type Aircraft	Type Engine	Status Code	Mode S Code	Fractional Ownership	Airworthiness Date	Other Name 1	Other Name 2	Other Name 3	Other Name 4	Other Name 5	Expiration Date	Unique ID	Kit MFR Code	Kit Model	Mose S Code Hex
133176	84720	7AC-3435	2110102	17003.0	1946.0	NaN	MASURA JUDITH E	PO BOX 415	NaN	GLENOMA	WA	983360415	S	41.0	US	20141118.0	20120405.0	1	4.0	1.0	V	52716221.0	NaN	19560319.0	NaN	NaN	NaN	NaN	NaN	20180430.0	552911.0	NaN	NaN	NaN
133177	4198V	NaN	NaN	NaN	NaN	NaN	CANCELLED/NOT ASSIGNED	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	51174423.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
133178	41981	NaN	NaN	NaN	NaN	NaN	CANCELLED/NOT ASSIGNED	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	51174431.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
133179	4141J	NaN	NaN	NaN	NaN	NaN	CANCELLED/NOT ASSIGNED	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	51162600.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
133180	4200J	NaN	NaN	NaN	NaN	NaN	CANCELLED/NOT ASSIGNED	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	51177000.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
133181	42028	NaN	NaN	NaN	NaN	NaN	CANCELLED/NOT ASSIGNED	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	51177136.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
133182	420AJ	NaN	NaN	NaN	NaN	NaN	CANCELLED/NOT ASSIGNED	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	51175650.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
133183	4202E	NaN	NaN	NaN	NaN	NaN	CANCELLED/NOT ASSIGNED	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	51177102.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
133184	4186W	NaN	NaN	NaN	NaN	NaN	CANCELLED/NOT ASSIGNED	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	5	51172427.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
133185	2345F	NaN	NaN	NaN	NaN	NaN	CANCELLED/NOT ASSIGNED	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent Decimal Number characters

Most frequent Uppercase Letter characters

Most frequent Space Separator characters

Most occurring scripts

Most frequent Common characters

Most frequent Latin characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Decimal Number characters

Most frequent Uppercase Letter characters

Most frequent Space Separator characters

Most frequent Dash Punctuation characters

Most frequent Lowercase Letter characters

Most frequent Other Punctuation characters

Most frequent Open Punctuation characters

Most frequent Close Punctuation characters

Most frequent Math Symbol characters

Most frequent Connector Punctuation characters

Most occurring scripts

Most frequent Common characters

Most frequent Latin characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Decimal Number characters

Most frequent Uppercase Letter characters

Most frequent Lowercase Letter characters

Most frequent Other Punctuation characters

Most frequent Math Symbol characters

Most occurring scripts

Most frequent Common characters

Most frequent Latin characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Uppercase Letter characters

Most frequent Space Separator characters

Most frequent Other Punctuation characters

Most frequent Decimal Number characters

Most frequent Dash Punctuation characters

Most frequent Lowercase Letter characters

Most frequent Open Punctuation characters

Most frequent Close Punctuation characters

Most frequent Math Symbol characters

Most occurring scripts

Most frequent Latin characters

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Uppercase Letter characters

Most frequent Space Separator characters

Most frequent Decimal Number characters

Most frequent Lowercase Letter characters

Most frequent Other Punctuation characters

Most frequent Dash Punctuation characters

Most frequent Open Punctuation characters

Most frequent Close Punctuation characters

Most frequent Math Symbol characters

Most occurring scripts

Most frequent Latin characters

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Lowercase Letter characters

Most frequent Decimal Number characters

Most frequent Space Separator characters

Most frequent Uppercase Letter characters

Most frequent Dash Punctuation characters